﻿CREATE TABLE [dbo].[DealMetrics]
(
	[ID]     [BIGINT]          IDENTITY (1, 1) NOT NULL,
	[DealID]		   BIGINT		   NOT NULL,
	[NumViews]         BIGINT          NULL,
    [NumPlannedVisits] BIGINT          NULL,
    [NumActualVisits]  BIGINT          NULL,
    [RevenueGenerated] FLOAT           NULL,
    [NumShared]        BIGINT          NULL,
)
